Customer Transactions Report
If this were a real report I would welcome the reader here and provide any context they require.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Distribution of overdraft limits
Relationship between account open and close dates
As can be seen in Figure 1, the rate of new accounts being opened is on a downward trend.
The trend is because while the number of accounts being opened between 2002 and 2018 have remained roughly steady, during the same period the number of accounts closing each month has been slowly rising, as seen in Figure 2.
Customers
Highest transaction value
The customer with the highest overall transaction value is account number 11336875, with £423,496.
Highest number of transactions
The 10 customers with the highest number of transactions are
| Account Number | Transactions Count |
|---|---|
| 11336875 | 693 |
| 12402243 | 686 |
| 10322173 | 500 |
| 12644022 | 472 |
| 10250507 | 468 |
| 10143829 | 426 |
| 11850488 | 424 |
| 10709272 | 421 |
| 12822022 | 402 |
| 11358265 | 386 |
Lowest transaction value
The customer with the lowest overall transaction value is account number 12857039, with £-50,165.
Transactions per month
| Number Customers | Month |
|---|---|
| 3,787 | Jan 2018 |
| 3,687 | Feb 2018 |
| 3,846 | Mar 2018 |
| 3,776 | Apr 2018 |
| 3,797 | May 2018 |
| 3,782 | Jun 2018 |
| 3,826 | Jul 2018 |
| 3,776 | Aug 2018 |
| 3,758 | Sep 2018 |
| 3,845 | Oct 2018 |
| 3,157 | Nov 2018 |
No transactions
There are 3,463 customers with no transactions.